Release 10.1A: OpenEdge Data Management:
SQL Development

Comparing OpenEdge SQL and Progress 4GL database objects

Rows and columns

A SQL database table is made up of rows and columns. A row is a single occurrence of data in a table. A column characterizes one attribute of a row of data. The Progress 4GL uses the term “field” instead of “column” and “record” instead of “row.”

Tables

A SQL table is a group of related data composed of rows and columns. The term “table” is used similarly in the Progress 4GL to describe a collection of fields and records.

Schemas

The term schema can be used three different ways:

When discussing a database created with OpenEdge SQL, a schema is defined as a collection of related database objects, such as tables or views. A SQL database can contain several schemas.
When referring to a database created with the Progress 4GL, schema is defined as the area in which all system and user information are stored. A Progress 4GL database contains only one schema area, referred to as the PUB (short for PUBLIC) schema.
While working from the OpenEdge SQL client, you can ensure you are working in the correct schema by using the SET SCHEMA command. For more information on using SET SCHEMA, see OpenEdge Data Management: SQL Reference .